Evaluate(Object[]) メソッド

Visual Basic
C#

'Declaration
 
Public Overloads MustOverride Function Evaluate( _
   ByVal args() As Object _
) As Object

public abstract object Evaluate( 
   object[] args
)

パラメータ

args: 関数の評価に使用する引数

戻り値の型

引数に関数を適用した結果を含むObject

次のサンプルコードは、コントロールに数式を追加せずに数式を計算します。

C#
Visual Basic

fpSpread1.ActiveSheet.Cells[0, 0].Value = 5;
fpSpread1.ActiveSheet.Cells[0, 1].Value = 10;
fpSpread1.ActiveSheet.Cells[0, 2].Value = 7;

object a1 = fpSpread1.ActiveSheet.GetValue(0, 0);
object a2 = fpSpread1.ActiveSheet.GetValue(0, 1);
object a3 = fpSpread1.ActiveSheet.GetValue(0, 2);

object[] args = new object[] { a1, a2, a3 };
object result = FarPoint.CalcEngine.FunctionInfo.SumFunction.Evaluate(args);
MessageBox.Show(result.ToString());

FpSpread1.ActiveSheet.Cells(0, 0).Value = 5
FpSpread1.ActiveSheet.Cells(0, 1).Value = 10
FpSpread1.ActiveSheet.Cells(0, 2).Value = 7

Dim a1 As Object = FpSpread1.ActiveSheet.GetValue(0, 0)
Dim a2 As Object = FpSpread1.ActiveSheet.GetValue(0, 1)
Dim a3 As Object = FpSpread1.ActiveSheet.GetValue(0, 2)

Dim args As Object() = New Object() {a1, a2, a3}
Dim result As Object = FarPoint.CalcEngine.FunctionInfo.SumFunction.Evaluate(args)
MessageBox.Show(result.ToString())

FunctionInfo クラス
 FunctionInfo メンバ
 オーバーロード一覧